<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>

<%@include file="top.jsp"%>
<%@include file="left.jsp"%>
<%
String strDesId = request.getParameter("desid");
int desid = 0;
if(null == strDesId || "".equals(strDesId)){

	}else{
		desid = Integer.parseInt(strDesId);
		Connection dbcDes = db.getConnection();
		String sqlDes = "SELECT d.name,e.emotionname,d.address,d.telephone,b.timename,d.avgconsume,d.about,s.shortname,d.createdate,d.hit FROM desination AS d, emotion AS e, shortcut AS s, bustime AS b WHERE d.emotionid=e.emotionid AND d.timeid=b.timeid AND d.shortid=s.shortid AND desid=?";
		PreparedStatement stmtDes = dbcDes.prepareStatement(sqlDes);
		stmtDes.setInt(1, desid);
		ResultSet rsDes = stmtDes.executeQuery();
		if(rsDes.next()){
 %>
<div id="content" class="align-right"><br/>
				<div id="changsuo">
                <div id="pic">
                  <img src="images/upload/des1.jpg" width="410" height="300" />
                  <%=rsDes.getString("name") %></div>
                  <h2>&nbsp;&nbsp;<%=rsDes.getString("name") %></h2>
                  <h3>&nbsp;&nbsp;<%=rsDes.getString("emotionname") %></h3>
                  <h4>&nbsp;&nbsp;&nbsp;&nbsp;<%=rsDes.getString("about") %><br/>店址:<br/>
&nbsp;&nbsp;&nbsp;&nbsp;<%=rsDes.getString("address")  %><br/>人均消费:<br/>&nbsp;&nbsp;&nbsp;&nbsp;<%=rsDes.getString("avgconsume") %><br /><br />营业时间：<%=rsDes.getString("shortname") %><br />联系电话：<%=rsDes.getString("telephone") %><br />时间：<%=rsDes.getString("createdate")  %></h4>
                  
				</div>
			</div>
<%}
rsDes.close();
dbcDes.close();
}
 %>
<!-- 特殊 选中样式 -->
<script type="text/javascript">
	
	$(document).ready(function(){
		
		/*选中，如下*/
		$('#li-shortcut').addClass('on');
		
	});
</script>

<%@include file="bottom.jsp"%>
